Basic FOLIO/LDP querying with R Notebooks

Explore patron groups

-- Query database using SQL but save to R object
SELECT * FROM public.user_users;

-- Query database using SQL but save to R object
SELECT * FROM public.user_groups;

Count users per patron group

SELECT patron_group,
       count(*) AS count
    FROM public.user_users
    GROUP BY patron_group
    ORDER BY count DESC;

Show the patron group names

SELECT coalesce(g.group, 'unknown') AS user_group,
       count(*) AS count
    FROM public.user_users AS u
        LEFT JOIN public.user_groups AS g ON u.patron_group = g.id
    GROUP BY user_group
    ORDER BY count DESC;